package org.jeecg.modules.flowermater.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.flowermater.entity.FlowerMaterialCount;

import java.util.List;

/**
 * 采后物资台---统计
 */
public interface FlowerMaterialCountMapper extends BaseMapper<FlowerMaterialCount> {

    /***
    *
     * 上期入库
    * @descriptionauthor  
    * @author gf
    * 2022/9/7 17:17
    * [  storehouse, cost, sDate, eDate, psnId]
    * @return java.util.List<org.jeecg.modules.flowermater.entity.FlowerMaterialCount>
    */
    List<FlowerMaterialCount> queryBeforIn(  @Param("storehouse") String storehouse, @Param("cost") String cost, @Param("sDate") String sDate, @Param("eDate") String eDate);

    /***
     *
     * 上期出库
     * @param
     * @param storehouse
     * @param cost
     * @param sDate
     * @param eDate
     * @return
     */
    List<FlowerMaterialCount> queryBeforout(  @Param("storehouse") String storehouse, @Param("cost") String cost, @Param("sDate") String sDate, @Param("eDate") String eDate);

    /**
     * 本期入库
     * @param
     * @param storehouse
     * @param cost
     * @param sDate
     * @param eDate
     * @return
     */
    List<FlowerMaterialCount> queryNowIn( @Param("storehouse") String storehouse, @Param("cost") String cost, @Param("sDate") String sDate, @Param("eDate") String eDate);

    /**
     * 本期出库
     * @param
     * @param storehouse
     * @param cost
     * @param sDate
     * @param eDate
     * @return
     */
    List<FlowerMaterialCount> queryNowOut(  @Param("storehouse") String storehouse, @Param("cost") String cost, @Param("sDate") String sDate, @Param("eDate") String eDate);


}
